﻿CREATE TABLE [dbo].[Order_Before] (
    [tId]                INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Id]                 INT              NOT NULL,
    [OId]                UNIQUEIDENTIFIER NULL,
    [CusPerson]          NVARCHAR (50)    NULL,
    [CusPersonTel]       NVARCHAR (50)    NULL,
    [CusDescription]     NVARCHAR (1000)  NULL,
    [CusEstimate]        NVARCHAR (200)   NULL,
    [WayId]              INT              NULL,
    [WayName]            NVARCHAR (50)    NULL,
    [ProcessId]          INT              NULL,
    [ProcessName]        NVARCHAR (50)    NULL,
    [TradeDate]          DATETIME         NULL,
    [Discount]           NVARCHAR (50)    NULL,
    [PaymentTypeId]      INT              NULL,
    [PaymentType]        NVARCHAR (50)    NULL,
    [BankId]             INT              NULL,
    [Bank]               NVARCHAR (50)    NULL,
    [PaymentDescription] NVARCHAR (200)   NULL,
    [OtherDescription]   NVARCHAR (1000)  NULL,
    [shjbh]              NVARCHAR (50)    CONSTRAINT [DF__Order_Bef__shjbh__34605C2B] DEFAULT ('') NULL,
    [htbh]               NVARCHAR (50)    CONSTRAINT [DF__Order_Befo__htbh__35548064] DEFAULT ('') NULL,
    [CreateDate]         DATETIME         CONSTRAINT [DF_Order_Before_CreateDate] DEFAULT (getdate()) NOT NULL,
    CONSTRAINT [PK_Order_Before] PRIMARY KEY CLUSTERED ([tId] ASC)
);

